﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="ESRPDataSetParteneri" targetNamespace="http://tempuri.org/ESRPDataSetParteneri.xsd" xmlns:mstns="http://tempuri.org/ESRPDataSetParteneri.xsd" xmlns="http://tempuri.org/ESRPDataSetParteneri.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="ESRPConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ESRPConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.ERPForms.Properties.Settings.GlobalReference.Default.ESRPConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ParteneriTableAdapter" GeneratorDataComponentClassName="ParteneriTableAdapter" Name="Parteneri" UserDataComponentName="ParteneriTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ESRPConnectionString (Settings)" DbObjectName="ESRP.dbo.Parteneri" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="Fill" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM Parteneri
WHERE        (IDPartener = @Original_IDPartener)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_IDPartener" ColumnName="IDPartener" DataSourceName="ESRP.dbo.Parteneri" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@Original_IDPartener" Precision="0" ProviderType="BigInt" Scale="0" Size="8" SourceColumn="IDPartener" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Parteneri] ([CUI], [Denumire], [IDBanca], [ContBancar], [Cont], [CodUnitate], [TipPartener], [IDJudet], [IDLocalitate], [Strada], [Nr], [AtributFiscal], [JudetRegComert], [NrRegComert], [AnRegComert], [NumeDelegat], [SerieAI], [NrAI], [MijlocTransport], [NrMijlocTransport], [CodPostal], [Telefon], [Fax], [ContClient], [ConditiiDePlata], [IDTara], [IDContactDelegat], [IDMijlocTransport]) VALUES (@CUI, @Denumire, @IDBanca, @ContBancar, @Cont, @CodUnitate, @TipPartener, @IDJudet, @IDLocalitate, @Strada, @Nr, @AtributFiscal, @JudetRegComert, @NrRegComert, @AnRegComert, @NumeDelegat, @SerieAI, @NrAI, @MijlocTransport, @NrMijlocTransport, @CodPostal, @Telefon, @Fax, @ContClient, @ConditiiDePlata, @IDTara, @IDContactDelegat, @IDMijlocTransport);
SELECT IDPartener, CUI, Denumire, IDBanca, ContBancar, Cont, CodUnitate, TipPartener, IDJudet, IDLocalitate, Strada, Nr, AtributFiscal, JudetRegComert, NrRegComert, AnRegComert, NumeDelegat, SerieAI, NrAI, MijlocTransport, NrMijlocTransport, CodPostal, Telefon, Fax, ContClient, ConditiiDePlata, IDTara, IDContactDelegat, IDMijlocTransport FROM Parteneri WHERE (IDPartener = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CUI" Precision="13" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="CUI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@IDBanca" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDBanca" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ContBancar" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContBancar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Cont" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cont" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TipPartener" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipPartener" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDJudet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDJudet" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDLocalitate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDLocalitate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Strada" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Strada" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AtributFiscal" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AtributFiscal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@JudetRegComert" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="JudetRegComert" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NrRegComert" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NrRegComert" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@AnRegComert" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="AnRegComert" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NumeDelegat" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumeDelegat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SerieAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SerieAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NrAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NrAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MijlocTransport" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MijlocTransport" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NrMijlocTransport" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NrMijlocTransport" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CodPostal" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodPostal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Telefon" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Telefon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Fax" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ContClient" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContClient" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ConditiiDePlata" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ConditiiDePlata" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDTara" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDTara" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDContactDelegat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDContactDelegat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@IDMijlocTransport" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDMijlocTransport" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDPartener, CUI, Denumire, IDBanca, ContBancar, Cont, CodUnitate, TipPartener, IDJudet, IDLocalitate, Strada, Nr, AtributFiscal, JudetRegComert, NrRegComert, AnRegComert, NumeDelegat, SerieAI, NrAI, MijlocTransport, NrMijlocTransport, CodPostal, Telefon, Fax, ContClient, ConditiiDePlata, IDTara, IDContactDelegat, IDMijlocTransport FROM Parteneri</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE       Parteneri
SET                CUI = @CUI, Denumire = @Denumire, IDBanca = @IDBanca, ContBancar = @ContBancar, Cont = @Cont, CodUnitate = @CodUnitate, TipPartener = @TipPartener, 
                         IDJudet = @IDJudet, IDLocalitate = @IDLocalitate, Strada = @Strada, Nr = @Nr, AtributFiscal = @AtributFiscal, JudetRegComert = @JudetRegComert, 
                         NrRegComert = @NrRegComert, AnRegComert = @AnRegComert, NumeDelegat = @NumeDelegat, SerieAI = @SerieAI, NrAI = @NrAI, 
                         MijlocTransport = @MijlocTransport, NrMijlocTransport = @NrMijlocTransport, CodPostal = @CodPostal, Telefon = @Telefon, Fax = @Fax, ContClient = @ContClient, 
                         ConditiiDePlata = @ConditiiDePlata, IDTara = @IDTara, IDContactDelegat = @IDContactDelegat, IDMijlocTransport = @IDMijlocTransport
WHERE        (IDPartener = @Original_IDPartener);  
SELECT IDPartener, CUI, Denumire, IDBanca, ContBancar, Cont, CodUnitate, TipPartener, IDJudet, IDLocalitate, Strada, Nr, AtributFiscal, JudetRegComert, NrRegComert, AnRegComert, NumeDelegat, SerieAI, NrAI, MijlocTransport, NrMijlocTransport, CodPostal, Telefon, Fax, ContClient, ConditiiDePlata, IDTara, IDContactDelegat, IDMijlocTransport FROM Parteneri WHERE (IDPartener = @IDPartener)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CUI" ColumnName="CUI" DataSourceName="ESRP.dbo.Parteneri" DataTypeServer="decimal(13, 0)" DbType="Decimal" Direction="Input" ParameterName="@CUI" Precision="13" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="CUI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Denumire" ColumnName="Denumire" DataSourceName="ESRP.dbo.Parteneri" DataTypeServer="varchar(200)" DbType="AnsiString" Direction="Input" ParameterName="@Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="200" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDBanca" ColumnName="IDBanca" DataSourceName="ESRP.dbo.Parteneri" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@IDBanca" Precision="0" ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="IDBanca" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ContBancar" ColumnName="ContBancar" DataSourceName="ESRP.dbo.Parteneri" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@ContBancar" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="ContBancar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Cont" ColumnName="Cont" DataSourceName="ESRP.dbo.Parteneri" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@Cont" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="Cont" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="CodUnitate" ColumnName="CodUnitate" DataSourceName="ESRP.dbo.Parteneri" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="TipPartener" ColumnName="TipPartener" DataSourceName="ESRP.dbo.Parteneri" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@TipPartener" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="TipPartener" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDJudet" ColumnName="IDJudet" DataSourceName="ESRP.dbo.Parteneri" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDJudet" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDJudet" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDLocalitate" ColumnName="IDLocalitate" DataSourceName="ESRP.dbo.Parteneri" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDLocalitate" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDLocalitate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Strada" ColumnName="Strada" DataSourceName="ESRP.dbo.Parteneri" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@Strada" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="Strada" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Nr" ColumnName="Nr" DataSourceName="ESRP.dbo.Parteneri" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@Nr" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="Nr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="AtributFiscal" ColumnName="AtributFiscal" DataSourceName="ESRP.dbo.Parteneri" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@AtributFiscal" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="AtributFiscal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="JudetRegComert" ColumnName="JudetRegComert" DataSourceName="ESRP.dbo.Parteneri" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@JudetRegComert" Precision="0" ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="JudetRegComert" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="NrRegComert" ColumnName="NrRegComert" DataSourceName="ESRP.dbo.Parteneri" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@NrRegComert" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="NrRegComert" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="AnRegComert" ColumnName="AnRegComert" DataSourceName="ESRP.dbo.Parteneri" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@AnRegComert" Precision="0" ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="AnRegComert" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="NumeDelegat" ColumnName="NumeDelegat" DataSourceName="ESRP.dbo.Parteneri" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@NumeDelegat" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="NumeDelegat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SerieAI" ColumnName="SerieAI" DataSourceName="ESRP.dbo.Parteneri" DataTypeServer="varchar(5)" DbType="AnsiString" Direction="Input" ParameterName="@SerieAI" Precision="0" ProviderType="VarChar" Scale="0" Size="5" SourceColumn="SerieAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="NrAI" ColumnName="NrAI" DataSourceName="ESRP.dbo.Parteneri" DataTypeServer="varchar(6)" DbType="AnsiString" Direction="Input" ParameterName="@NrAI" Precision="0" ProviderType="VarChar" Scale="0" Size="6" SourceColumn="NrAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="MijlocTransport" ColumnName="MijlocTransport" DataSourceName="ESRP.dbo.Parteneri" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@MijlocTransport" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="MijlocTransport" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="NrMijlocTransport" ColumnName="NrMijlocTransport" DataSourceName="ESRP.dbo.Parteneri" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@NrMijlocTransport" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="NrMijlocTransport" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="CodPostal" ColumnName="CodPostal" DataSourceName="ESRP.dbo.Parteneri" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@CodPostal" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="CodPostal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Telefon" ColumnName="Telefon" DataSourceName="ESRP.dbo.Parteneri" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@Telefon" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="Telefon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Fax" ColumnName="Fax" DataSourceName="ESRP.dbo.Parteneri" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@Fax" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="Fax" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="ContClient" ColumnName="ContClient" DataSourceName="ESRP.dbo.Parteneri" DataTypeServer="TipCont" DbType="AnsiString" Direction="Input" ParameterName="@ContClient" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="ContClient" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="ConditiiDePlata" ColumnName="ConditiiDePlata" DataSourceName="ESRP.dbo.Parteneri" DataTypeServer="varchar(250)" DbType="AnsiString" Direction="Input" ParameterName="@ConditiiDePlata" Precision="0" ProviderType="VarChar" Scale="0" Size="250" SourceColumn="ConditiiDePlata" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="IDTara" ColumnName="IDTara" DataSourceName="ESRP.dbo.Parteneri" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDTara" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDTara" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="IDContactDelegat" ColumnName="IDContactDelegat" DataSourceName="ESRP.dbo.Parteneri" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDContactDelegat" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDContactDelegat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="IDMijlocTransport" ColumnName="IDMijlocTransport" DataSourceName="ESRP.dbo.Parteneri" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@IDMijlocTransport" Precision="0" ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="IDMijlocTransport" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_IDPartener" ColumnName="IDPartener" DataSourceName="ESRP.dbo.Parteneri" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@Original_IDPartener" Precision="0" ProviderType="BigInt" Scale="0" Size="8" SourceColumn="IDPartener" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDPartener" ColumnName="IDPartener" DataSourceName="ESRP.dbo.Parteneri" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@IDPartener" Precision="0" ProviderType="BigInt" Scale="0" Size="8" SourceColumn="IDPartener" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDPartener" DataSetColumn="IDPartener" />
              <Mapping SourceColumn="CUI" DataSetColumn="CUI" />
              <Mapping SourceColumn="Denumire" DataSetColumn="Denumire" />
              <Mapping SourceColumn="IDBanca" DataSetColumn="IDBanca" />
              <Mapping SourceColumn="ContBancar" DataSetColumn="ContBancar" />
              <Mapping SourceColumn="Cont" DataSetColumn="Cont" />
              <Mapping SourceColumn="CodUnitate" DataSetColumn="CodUnitate" />
              <Mapping SourceColumn="TipPartener" DataSetColumn="TipPartener" />
              <Mapping SourceColumn="IDJudet" DataSetColumn="IDJudet" />
              <Mapping SourceColumn="IDLocalitate" DataSetColumn="IDLocalitate" />
              <Mapping SourceColumn="Strada" DataSetColumn="Strada" />
              <Mapping SourceColumn="Nr" DataSetColumn="Nr" />
              <Mapping SourceColumn="AtributFiscal" DataSetColumn="AtributFiscal" />
              <Mapping SourceColumn="JudetRegComert" DataSetColumn="JudetRegComert" />
              <Mapping SourceColumn="NrRegComert" DataSetColumn="NrRegComert" />
              <Mapping SourceColumn="AnRegComert" DataSetColumn="AnRegComert" />
              <Mapping SourceColumn="NumeDelegat" DataSetColumn="NumeDelegat" />
              <Mapping SourceColumn="SerieAI" DataSetColumn="SerieAI" />
              <Mapping SourceColumn="NrAI" DataSetColumn="NrAI" />
              <Mapping SourceColumn="MijlocTransport" DataSetColumn="MijlocTransport" />
              <Mapping SourceColumn="NrMijlocTransport" DataSetColumn="NrMijlocTransport" />
              <Mapping SourceColumn="CodPostal" DataSetColumn="CodPostal" />
              <Mapping SourceColumn="Telefon" DataSetColumn="Telefon" />
              <Mapping SourceColumn="Fax" DataSetColumn="Fax" />
              <Mapping SourceColumn="ContClient" DataSetColumn="ContClient" />
              <Mapping SourceColumn="ConditiiDePlata" DataSetColumn="ConditiiDePlata" />
              <Mapping SourceColumn="IDTara" DataSetColumn="IDTara" />
              <Mapping SourceColumn="IDContactDelegat" DataSetColumn="IDContactDelegat" />
              <Mapping SourceColumn="IDMijlocTransport" DataSetColumn="IDMijlocTransport" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ESRPConnectionString (Settings)" DbObjectName="ESRP.dbo.Parteneri" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByDenumire" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByDenumire" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillByDenumire">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT IDPartener, Denumire, IDBanca, ContBancar, Cont, CodUnitate, TipPartener, IDJudet, IDLocalitate, Strada, Nr, AtributFiscal, JudetRegComert, NrRegComert, AnRegComert, NumeDelegat, SerieAI, NrAI, MijlocTransport, NrMijlocTransport, CUI, CodPostal, Telefon, Fax, ContClient, ConditiiDePlata, IDTara, IDContactDelegat, IDMijlocTransport FROM Parteneri WHERE (IDPartener &lt;&gt; 0) AND (Denumire LIKE @den + '%')</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="den" ColumnName="Denumire" DataSourceName="ESRP.dbo.Parteneri" DataTypeServer="varchar(200)" DbType="AnsiString" Direction="Input" ParameterName="@den" Precision="0" ProviderType="VarChar" Scale="0" Size="200" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ESRPConnectionString (Settings)" DbObjectName="ESRP.dbo.Parteneri" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByDenumireUnitate" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByDenumireUnitate" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="FillByDenumireUnitate">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT IDPartener, Denumire, IDBanca, ContBancar, Cont, CodUnitate, TipPartener, IDJudet, IDLocalitate, Strada, Nr, AtributFiscal, JudetRegComert, NrRegComert, AnRegComert, NumeDelegat, SerieAI, NrAI, MijlocTransport, NrMijlocTransport, CUI, CodPostal, Telefon, Fax, ContClient, ConditiiDePlata, IDTara, IDContactDelegat, IDMijlocTransport FROM Parteneri WHERE (IDPartener &lt;&gt; 0) AND (Denumire LIKE @den + '%') AND (CodUnitate = @CodUnitate)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="den" ColumnName="Denumire" DataSourceName="ESRP.dbo.Parteneri" DataTypeServer="varchar(200)" DbType="AnsiString" Direction="Input" ParameterName="@den" Precision="0" ProviderType="VarChar" Scale="0" Size="200" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="CodUnitate" ColumnName="CodUnitate" DataSourceName="ESRP.dbo.Parteneri" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ESRPConnectionString (Settings)" DbObjectName="ESRP.dbo.erpforms_FiltreazaParteneri" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="FillByFiltru" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByFiltru" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="FillByFiltru">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.erpforms_FiltreazaParteneri</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@filtru" Precision="0" ProviderType="VarChar" Scale="0" Size="5000" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ESRPConnectionString (Settings)" DbObjectName="ESRP.dbo.exBug_AfiseazaParteneriFolositi" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="FillByParteneriFolositi" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByParteneriFolositi" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="FillByParteneriFolositi">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.exBug_AfiseazaParteneriFolositi</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@CodUnitate" Precision="5" ProviderType="SmallInt" Scale="0" Size="2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@Afiseaza" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ESRPConnectionString (Settings)" DbObjectName="ESRP.dbo.Parteneri" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByUnitate" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByUnitate" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy4" UserSourceName="FillByUnitate">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT IDPartener, Denumire, IDBanca, ContBancar, Cont, CodUnitate, TipPartener, IDJudet, IDLocalitate, Strada, Nr, AtributFiscal, JudetRegComert, NrRegComert, AnRegComert, NumeDelegat, SerieAI, NrAI, MijlocTransport, NrMijlocTransport, CUI, CodPostal, Telefon, Fax, ContClient, ConditiiDePlata, IDTara, IDContactDelegat, IDMijlocTransport FROM Parteneri WHERE (IDPartener &lt;&gt; 0) AND (CodUnitate = @CodUnitate)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CodUnitate" ColumnName="CodUnitate" DataSourceName="ESRP.dbo.Parteneri" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="BanciTableAdapter" GeneratorDataComponentClassName="BanciTableAdapter" Name="Banci" UserDataComponentName="BanciTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ESRPConnectionString (Settings)" DbObjectName="ESRP.dbo.Banci" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Banci] WHERE (([IdBanca] = @Original_IdBanca) AND ([Denumire] = @Original_Denumire) AND ([BIC] = @Original_BIC))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_IdBanca" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IdBanca" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BIC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BIC" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Banci] ([Denumire], [BIC]) VALUES (@Denumire, @BIC);
SELECT IdBanca, Denumire, BIC FROM Banci WHERE (IdBanca = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BIC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BIC" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IdBanca, Denumire, BIC FROM dbo.Banci</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Banci] SET [Denumire] = @Denumire, [BIC] = @BIC WHERE (([IdBanca] = @Original_IdBanca) AND ([Denumire] = @Original_Denumire) AND ([BIC] = @Original_BIC));
SELECT IdBanca, Denumire, BIC FROM Banci WHERE (IdBanca = @IdBanca)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BIC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BIC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_IdBanca" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IdBanca" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BIC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BIC" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IdBanca" ColumnName="IdBanca" DataSourceName="ESRP.dbo.Banci" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@IdBanca" Precision="0" ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="IdBanca" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdBanca" DataSetColumn="IdBanca" />
              <Mapping SourceColumn="Denumire" DataSetColumn="Denumire" />
              <Mapping SourceColumn="BIC" DataSetColumn="BIC" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ConturiTableAdapter" GeneratorDataComponentClassName="ConturiTableAdapter" Name="Conturi" UserDataComponentName="ConturiTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ESRPConnectionString (Settings)" DbObjectName="ESRP.dbo.Conturi" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="Fill" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Conturi] WHERE (([Cont] = @Original_Cont) AND ([CodUnitate] = @Original_CodUnitate) AND ([Denumire] = @Original_Denumire) AND ([Tip] = @Original_Tip) AND ([Terminal] = @Original_Terminal) AND ([ContParinte] = @Original_ContParinte) AND ([EsteAnalitic] = @Original_EsteAnalitic) AND ([DebitInitial] = @Original_DebitInitial) AND ([CreditInitial] = @Original_CreditInitial) AND ([DebitPrecedent] = @Original_DebitPrecedent) AND ([CreditPrecedent] = @Original_CreditPrecedent) AND ([Categorie] = @Original_Categorie) AND ([RulajDebit] = @Original_RulajDebit) AND ([RulajCredit] = @Original_RulajCredit) AND ([Sold] = @Original_Sold) AND ((@IsNull_SortValue = 1 AND [SortValue] IS NULL) OR ([SortValue] = @Original_SortValue)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Cont" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cont" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Tip" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Tip" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Terminal" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Terminal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ContParinte" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContParinte" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_EsteAnalitic" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="EsteAnalitic" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_DebitInitial" Precision="20" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DebitInitial" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_CreditInitial" Precision="20" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CreditInitial" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_DebitPrecedent" Precision="20" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DebitPrecedent" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_CreditPrecedent" Precision="20" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CreditPrecedent" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_Categorie" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Categorie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_RulajDebit" Precision="20" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="RulajDebit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_RulajCredit" Precision="20" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="RulajCredit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Sold" Precision="20" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Sold" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SortValue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SortValue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SortValue" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SortValue" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Conturi] ([Cont], [CodUnitate], [Denumire], [Tip], [Terminal], [ContParinte], [EsteAnalitic], [DebitInitial], [CreditInitial], [DebitPrecedent], [CreditPrecedent], [Categorie], [RulajDebit], [RulajCredit], [Sold]) VALUES (@Cont, @CodUnitate, @Denumire, @Tip, @Terminal, @ContParinte, @EsteAnalitic, @DebitInitial, @CreditInitial, @DebitPrecedent, @CreditPrecedent, @Categorie, @RulajDebit, @RulajCredit, @Sold);
SELECT Cont, CodUnitate, Denumire, Tip, Terminal, ContParinte, EsteAnalitic, DebitInitial, CreditInitial, DebitPrecedent, CreditPrecedent, Categorie, RulajDebit, RulajCredit, Sold, SortValue FROM Conturi WHERE (CodUnitate = @CodUnitate) AND (Cont = @Cont)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Cont" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cont" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Tip" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Tip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Terminal" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Terminal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ContParinte" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContParinte" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@EsteAnalitic" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="EsteAnalitic" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@DebitInitial" Precision="20" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DebitInitial" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CreditInitial" Precision="20" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CreditInitial" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@DebitPrecedent" Precision="20" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DebitPrecedent" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CreditPrecedent" Precision="20" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CreditPrecedent" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Categorie" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Categorie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@RulajDebit" Precision="20" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="RulajDebit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@RulajCredit" Precision="20" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="RulajCredit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Sold" Precision="20" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Sold" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Cont, CodUnitate, Denumire, Tip, Terminal, ContParinte, EsteAnalitic, DebitInitial, CreditInitial, DebitPrecedent, CreditPrecedent, Categorie, RulajDebit, RulajCredit, Sold, SortValue FROM dbo.Conturi</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Conturi] SET [Cont] = @Cont, [CodUnitate] = @CodUnitate, [Denumire] = @Denumire, [Tip] = @Tip, [Terminal] = @Terminal, [ContParinte] = @ContParinte, [EsteAnalitic] = @EsteAnalitic, [DebitInitial] = @DebitInitial, [CreditInitial] = @CreditInitial, [DebitPrecedent] = @DebitPrecedent, [CreditPrecedent] = @CreditPrecedent, [Categorie] = @Categorie, [RulajDebit] = @RulajDebit, [RulajCredit] = @RulajCredit, [Sold] = @Sold WHERE (([Cont] = @Original_Cont) AND ([CodUnitate] = @Original_CodUnitate) AND ([Denumire] = @Original_Denumire) AND ([Tip] = @Original_Tip) AND ([Terminal] = @Original_Terminal) AND ([ContParinte] = @Original_ContParinte) AND ([EsteAnalitic] = @Original_EsteAnalitic) AND ([DebitInitial] = @Original_DebitInitial) AND ([CreditInitial] = @Original_CreditInitial) AND ([DebitPrecedent] = @Original_DebitPrecedent) AND ([CreditPrecedent] = @Original_CreditPrecedent) AND ([Categorie] = @Original_Categorie) AND ([RulajDebit] = @Original_RulajDebit) AND ([RulajCredit] = @Original_RulajCredit) AND ([Sold] = @Original_Sold) AND ((@IsNull_SortValue = 1 AND [SortValue] IS NULL) OR ([SortValue] = @Original_SortValue)));
SELECT Cont, CodUnitate, Denumire, Tip, Terminal, ContParinte, EsteAnalitic, DebitInitial, CreditInitial, DebitPrecedent, CreditPrecedent, Categorie, RulajDebit, RulajCredit, Sold, SortValue FROM Conturi WHERE (CodUnitate = @CodUnitate) AND (Cont = @Cont)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Cont" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cont" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Tip" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Tip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Terminal" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Terminal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ContParinte" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContParinte" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@EsteAnalitic" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="EsteAnalitic" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@DebitInitial" Precision="20" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DebitInitial" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CreditInitial" Precision="20" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CreditInitial" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@DebitPrecedent" Precision="20" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DebitPrecedent" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CreditPrecedent" Precision="20" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CreditPrecedent" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Categorie" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Categorie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@RulajDebit" Precision="20" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="RulajDebit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@RulajCredit" Precision="20" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="RulajCredit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Sold" Precision="20" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Sold" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Cont" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cont" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Tip" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Tip" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Terminal" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Terminal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ContParinte" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContParinte" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_EsteAnalitic" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="EsteAnalitic" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_DebitInitial" Precision="20" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DebitInitial" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_CreditInitial" Precision="20" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CreditInitial" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_DebitPrecedent" Precision="20" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DebitPrecedent" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_CreditPrecedent" Precision="20" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CreditPrecedent" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_Categorie" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Categorie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_RulajDebit" Precision="20" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="RulajDebit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_RulajCredit" Precision="20" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="RulajCredit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Sold" Precision="20" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Sold" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SortValue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SortValue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SortValue" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SortValue" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Cont" DataSetColumn="Cont" />
              <Mapping SourceColumn="CodUnitate" DataSetColumn="CodUnitate" />
              <Mapping SourceColumn="Denumire" DataSetColumn="Denumire" />
              <Mapping SourceColumn="Tip" DataSetColumn="Tip" />
              <Mapping SourceColumn="Terminal" DataSetColumn="Terminal" />
              <Mapping SourceColumn="ContParinte" DataSetColumn="ContParinte" />
              <Mapping SourceColumn="EsteAnalitic" DataSetColumn="EsteAnalitic" />
              <Mapping SourceColumn="DebitInitial" DataSetColumn="DebitInitial" />
              <Mapping SourceColumn="CreditInitial" DataSetColumn="CreditInitial" />
              <Mapping SourceColumn="DebitPrecedent" DataSetColumn="DebitPrecedent" />
              <Mapping SourceColumn="CreditPrecedent" DataSetColumn="CreditPrecedent" />
              <Mapping SourceColumn="Categorie" DataSetColumn="Categorie" />
              <Mapping SourceColumn="RulajDebit" DataSetColumn="RulajDebit" />
              <Mapping SourceColumn="RulajCredit" DataSetColumn="RulajCredit" />
              <Mapping SourceColumn="Sold" DataSetColumn="Sold" />
              <Mapping SourceColumn="SortValue" DataSetColumn="SortValue" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ESRPConnectionString (Settings)" DbObjectName="ESRP.dbo.Conturi" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByCodUnitate" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByCodUnitate" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillByCodUnitate">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Cont, CodUnitate, Denumire, Tip, Terminal, ContParinte, EsteAnalitic, DebitInitial, CreditInitial, DebitPrecedent, CreditPrecedent, Categorie, RulajDebit, RulajCredit, Sold, SortValue FROM dbo.Conturi
WHERE CodUnitate=@CodUnitate ORDER BY Cont</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CodUnitate" ColumnName="CodUnitate" DataSourceName="ESRP.dbo.Conturi" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="JudeteTableAdapter" GeneratorDataComponentClassName="JudeteTableAdapter" Name="Judete" UserDataComponentName="JudeteTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ESRPConnectionString (Settings)" DbObjectName="ESRP.dbo.Judete" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Judete] WHERE (([IDJudet] = @Original_IDJudet) AND ((@IsNull_Nume = 1 AND [Nume] IS NULL) OR ([Nume] = @Original_Nume)) AND ((@IsNull_Sigla = 1 AND [Sigla] IS NULL) OR ([Sigla] = @Original_Sigla)) AND ((@IsNull_PrefixTelefonic = 1 AND [PrefixTelefonic] IS NULL) OR ([PrefixTelefonic] = @Original_PrefixTelefonic)) AND ((@IsNull_ResedintaJudet = 1 AND [ResedintaJudet] IS NULL) OR ([ResedintaJudet] = @Original_ResedintaJudet)) AND ((@IsNull_IDTara = 1 AND [IDTara] IS NULL) OR ([IDTara] = @Original_IDTara)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDJudet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDJudet" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nume" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Sigla" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Sigla" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PrefixTelefonic" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PrefixTelefonic" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PrefixTelefonic" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PrefixTelefonic" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ResedintaJudet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ResedintaJudet" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ResedintaJudet" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ResedintaJudet" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDTara" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDTara" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDTara" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDTara" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Judete] ([Nume], [Sigla], [PrefixTelefonic], [ResedintaJudet], [IDTara]) VALUES (@Nume, @Sigla, @PrefixTelefonic, @ResedintaJudet, @IDTara);
SELECT IDJudet, Nume, Sigla, PrefixTelefonic, ResedintaJudet, IDTara FROM Judete WHERE (IDJudet = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Sigla" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PrefixTelefonic" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PrefixTelefonic" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ResedintaJudet" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ResedintaJudet" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDTara" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDTara" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDJudet, Nume, Sigla, PrefixTelefonic, ResedintaJudet, IDTara FROM Judete</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Judete] SET [Nume] = @Nume, [Sigla] = @Sigla, [PrefixTelefonic] = @PrefixTelefonic, [ResedintaJudet] = @ResedintaJudet, [IDTara] = @IDTara WHERE (([IDJudet] = @Original_IDJudet) AND ((@IsNull_Nume = 1 AND [Nume] IS NULL) OR ([Nume] = @Original_Nume)) AND ((@IsNull_Sigla = 1 AND [Sigla] IS NULL) OR ([Sigla] = @Original_Sigla)) AND ((@IsNull_PrefixTelefonic = 1 AND [PrefixTelefonic] IS NULL) OR ([PrefixTelefonic] = @Original_PrefixTelefonic)) AND ((@IsNull_ResedintaJudet = 1 AND [ResedintaJudet] IS NULL) OR ([ResedintaJudet] = @Original_ResedintaJudet)) AND ((@IsNull_IDTara = 1 AND [IDTara] IS NULL) OR ([IDTara] = @Original_IDTara)));
SELECT IDJudet, Nume, Sigla, PrefixTelefonic, ResedintaJudet, IDTara FROM Judete WHERE (IDJudet = @IDJudet)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Sigla" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PrefixTelefonic" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PrefixTelefonic" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ResedintaJudet" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ResedintaJudet" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDTara" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDTara" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDJudet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDJudet" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nume" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Sigla" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Sigla" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PrefixTelefonic" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PrefixTelefonic" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PrefixTelefonic" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PrefixTelefonic" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ResedintaJudet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ResedintaJudet" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ResedintaJudet" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ResedintaJudet" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDTara" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDTara" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDTara" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDTara" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDJudet" ColumnName="IDJudet" DataSourceName="ESRP.dbo.Judete" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDJudet" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDJudet" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDJudet" DataSetColumn="IDJudet" />
              <Mapping SourceColumn="Nume" DataSetColumn="Nume" />
              <Mapping SourceColumn="Sigla" DataSetColumn="Sigla" />
              <Mapping SourceColumn="PrefixTelefonic" DataSetColumn="PrefixTelefonic" />
              <Mapping SourceColumn="ResedintaJudet" DataSetColumn="ResedintaJudet" />
              <Mapping SourceColumn="IDTara" DataSetColumn="IDTara" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LocalitatiTableAdapter" GeneratorDataComponentClassName="LocalitatiTableAdapter" Name="Localitati" UserDataComponentName="LocalitatiTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ESRPConnectionString (Settings)" DbObjectName="ESRP.dbo.Localitati" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="Fill" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Localitati] WHERE (([IDLocalitate] = @Original_IDLocalitate) AND ((@IsNull_Nume = 1 AND [Nume] IS NULL) OR ([Nume] = @Original_Nume)) AND ((@IsNull_CodPostal = 1 AND [CodPostal] IS NULL) OR ([CodPostal] = @Original_CodPostal)) AND ((@IsNull_IDJudet = 1 AND [IDJudet] IS NULL) OR ([IDJudet] = @Original_IDJudet)) AND ((@IsNull_PrefixTelefonic = 1 AND [PrefixTelefonic] IS NULL) OR ([PrefixTelefonic] = @Original_PrefixTelefonic)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDLocalitate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDLocalitate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nume" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodPostal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodPostal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CodPostal" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodPostal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDJudet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDJudet" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDJudet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDJudet" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PrefixTelefonic" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PrefixTelefonic" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PrefixTelefonic" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PrefixTelefonic" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Localitati] ([Nume], [CodPostal], [IDJudet], [PrefixTelefonic]) VALUES (@Nume, @CodPostal, @IDJudet, @PrefixTelefonic);
SELECT IDLocalitate, Nume, CodPostal, IDJudet, PrefixTelefonic FROM Localitati WHERE (IDLocalitate = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CodPostal" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodPostal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDJudet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDJudet" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PrefixTelefonic" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PrefixTelefonic" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT IDLocalitate, Nume, CodPostal, IDJudet, PrefixTelefonic FROM dbo.Localitati</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Localitati] SET [Nume] = @Nume, [CodPostal] = @CodPostal, [IDJudet] = @IDJudet, [PrefixTelefonic] = @PrefixTelefonic WHERE (([IDLocalitate] = @Original_IDLocalitate) AND ((@IsNull_Nume = 1 AND [Nume] IS NULL) OR ([Nume] = @Original_Nume)) AND ((@IsNull_CodPostal = 1 AND [CodPostal] IS NULL) OR ([CodPostal] = @Original_CodPostal)) AND ((@IsNull_IDJudet = 1 AND [IDJudet] IS NULL) OR ([IDJudet] = @Original_IDJudet)) AND ((@IsNull_PrefixTelefonic = 1 AND [PrefixTelefonic] IS NULL) OR ([PrefixTelefonic] = @Original_PrefixTelefonic)));
SELECT IDLocalitate, Nume, CodPostal, IDJudet, PrefixTelefonic FROM Localitati WHERE (IDLocalitate = @IDLocalitate)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CodPostal" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodPostal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDJudet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDJudet" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PrefixTelefonic" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PrefixTelefonic" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDLocalitate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDLocalitate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nume" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodPostal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodPostal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CodPostal" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodPostal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDJudet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDJudet" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDJudet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDJudet" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PrefixTelefonic" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PrefixTelefonic" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PrefixTelefonic" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PrefixTelefonic" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDLocalitate" ColumnName="IDLocalitate" DataSourceName="ESRP.dbo.Localitati" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDLocalitate" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDLocalitate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDLocalitate" DataSetColumn="IDLocalitate" />
              <Mapping SourceColumn="Nume" DataSetColumn="Nume" />
              <Mapping SourceColumn="CodPostal" DataSetColumn="CodPostal" />
              <Mapping SourceColumn="IDJudet" DataSetColumn="IDJudet" />
              <Mapping SourceColumn="PrefixTelefonic" DataSetColumn="PrefixTelefonic" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ESRPConnectionString (Settings)" DbObjectName="ESRP.dbo.Localitati" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByJudet" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByJudet" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillByJudet">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT IDLocalitate, Nume, CodPostal, IDJudet, PrefixTelefonic FROM dbo.Localitati
WHERE [IDJudet]=@IDJudet</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="IDJudet" ColumnName="IDJudet" DataSourceName="ESRP.dbo.Localitati" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDJudet" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDJudet" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TariTableAdapter" GeneratorDataComponentClassName="TariTableAdapter" Name="Tari" UserDataComponentName="TariTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ESRPConnectionString (Settings)" DbObjectName="ESRP.dbo.Tari" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Tari] WHERE (([IDTara] = @Original_IDTara) AND ((@IsNull_NUME = 1 AND [NUME] IS NULL) OR ([NUME] = @Original_NUME)) AND ((@IsNull_SIGLA = 1 AND [SIGLA] IS NULL) OR ([SIGLA] = @Original_SIGLA)) AND ((@IsNull_preftel = 1 AND [preftel] IS NULL) OR ([preftel] = @Original_preftel)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDTara" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDTara" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NUME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NUME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NUME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NUME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SIGLA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SIGLA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_SIGLA" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="SIGLA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_preftel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="preftel" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_preftel" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="preftel" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Tari] ([NUME], [SIGLA], [preftel]) VALUES (@NUME, @SIGLA, @preftel);
SELECT IDTara, NUME, SIGLA, preftel FROM Tari WHERE (IDTara = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NUME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NUME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@SIGLA" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="SIGLA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@preftel" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="preftel" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDTara, NUME, SIGLA, preftel FROM dbo.Tari</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Tari] SET [NUME] = @NUME, [SIGLA] = @SIGLA, [preftel] = @preftel WHERE (([IDTara] = @Original_IDTara) AND ((@IsNull_NUME = 1 AND [NUME] IS NULL) OR ([NUME] = @Original_NUME)) AND ((@IsNull_SIGLA = 1 AND [SIGLA] IS NULL) OR ([SIGLA] = @Original_SIGLA)) AND ((@IsNull_preftel = 1 AND [preftel] IS NULL) OR ([preftel] = @Original_preftel)));
SELECT IDTara, NUME, SIGLA, preftel FROM Tari WHERE (IDTara = @IDTara)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NUME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NUME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@SIGLA" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="SIGLA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@preftel" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="preftel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDTara" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDTara" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NUME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NUME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NUME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NUME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SIGLA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SIGLA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_SIGLA" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="SIGLA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_preftel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="preftel" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_preftel" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="preftel" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDTara" ColumnName="IDTara" DataSourceName="ESRP.dbo.Tari" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDTara" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDTara" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDTara" DataSetColumn="IDTara" />
              <Mapping SourceColumn="NUME" DataSetColumn="NUME" />
              <Mapping SourceColumn="SIGLA" DataSetColumn="SIGLA" />
              <Mapping SourceColumn="preftel" DataSetColumn="preftel" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ContactTableAdapter" GeneratorDataComponentClassName="ContactTableAdapter" Name="Contact" UserDataComponentName="ContactTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ESRPConnectionString (Settings)" DbObjectName="ESRP.dbo.Contact" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Contact] WHERE (([IDContact] = @Original_IDContact) AND ((@IsNull_Nume = 1 AND [Nume] IS NULL) OR ([Nume] = @Original_Nume)) AND ((@IsNull_Prenume = 1 AND [Prenume] IS NULL) OR ([Prenume] = @Original_Prenume)) AND ((@IsNull_IDTipContact = 1 AND [IDTipContact] IS NULL) OR ([IDTipContact] = @Original_IDTipContact)) AND ((@IsNull_CNP = 1 AND [CNP] IS NULL) OR ([CNP] = @Original_CNP)) AND ((@IsNull_StareCivila = 1 AND [StareCivila] IS NULL) OR ([StareCivila] = @Original_StareCivila)) AND ((@IsNull_Functie = 1 AND [Functie] IS NULL) OR ([Functie] = @Original_Functie)) AND ((@IsNull_Departament = 1 AND [Departament] IS NULL) OR ([Departament] = @Original_Departament)) AND ((@IsNull_TipAI = 1 AND [TipAI] IS NULL) OR ([TipAI] = @Original_TipAI)) AND ((@IsNull_SerieAI = 1 AND [SerieAI] IS NULL) OR ([SerieAI] = @Original_SerieAI)) AND ((@IsNull_NumarAI = 1 AND [NumarAI] IS NULL) OR ([NumarAI] = @Original_NumarAI)) AND ((@IsNull_IDPartener = 1 AND [IDPartener] IS NULL) OR ([IDPartener] = @Original_IDPartener)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDContact" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDContact" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nume" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Prenume" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Prenume" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Prenume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Prenume" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDTipContact" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDTipContact" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_IDTipContact" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDTipContact" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CNP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CNP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_CNP" Precision="13" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="CNP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StareCivila" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StareCivila" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_StareCivila" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="StareCivila" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Functie" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Functie" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Functie" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Functie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Departament" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Departament" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Departament" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Departament" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TipAI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TipAI" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TipAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SerieAI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SerieAI" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SerieAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SerieAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NumarAI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumarAI" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_NumarAI" Precision="10" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NumarAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDPartener" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDPartener" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_IDPartener" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="IDPartener" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Contact] ([Nume], [Prenume], [IDTipContact], [CNP], [StareCivila], [Functie], [Departament], [TipAI], [SerieAI], [NumarAI], [IDPartener]) VALUES (@Nume, @Prenume, @IDTipContact, @CNP, @StareCivila, @Functie, @Departament, @TipAI, @SerieAI, @NumarAI, @IDPartener);
SELECT IDContact, Nume, Prenume, IDTipContact, CNP, StareCivila, Functie, Departament, TipAI, SerieAI, NumarAI, IDPartener FROM Contact WHERE (IDContact = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Prenume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Prenume" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@IDTipContact" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDTipContact" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CNP" Precision="13" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="CNP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@StareCivila" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="StareCivila" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Functie" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Functie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Departament" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Departament" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TipAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SerieAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SerieAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@NumarAI" Precision="10" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NumarAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@IDPartener" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="IDPartener" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDContact, Nume, Prenume, IDTipContact, CNP, StareCivila, Functie, Departament, TipAI, SerieAI, NumarAI, IDPartener FROM dbo.Contact</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Contact] SET [Nume] = @Nume, [Prenume] = @Prenume, [IDTipContact] = @IDTipContact, [CNP] = @CNP, [StareCivila] = @StareCivila, [Functie] = @Functie, [Departament] = @Departament, [TipAI] = @TipAI, [SerieAI] = @SerieAI, [NumarAI] = @NumarAI, [IDPartener] = @IDPartener WHERE (([IDContact] = @Original_IDContact) AND ((@IsNull_Nume = 1 AND [Nume] IS NULL) OR ([Nume] = @Original_Nume)) AND ((@IsNull_Prenume = 1 AND [Prenume] IS NULL) OR ([Prenume] = @Original_Prenume)) AND ((@IsNull_IDTipContact = 1 AND [IDTipContact] IS NULL) OR ([IDTipContact] = @Original_IDTipContact)) AND ((@IsNull_CNP = 1 AND [CNP] IS NULL) OR ([CNP] = @Original_CNP)) AND ((@IsNull_StareCivila = 1 AND [StareCivila] IS NULL) OR ([StareCivila] = @Original_StareCivila)) AND ((@IsNull_Functie = 1 AND [Functie] IS NULL) OR ([Functie] = @Original_Functie)) AND ((@IsNull_Departament = 1 AND [Departament] IS NULL) OR ([Departament] = @Original_Departament)) AND ((@IsNull_TipAI = 1 AND [TipAI] IS NULL) OR ([TipAI] = @Original_TipAI)) AND ((@IsNull_SerieAI = 1 AND [SerieAI] IS NULL) OR ([SerieAI] = @Original_SerieAI)) AND ((@IsNull_NumarAI = 1 AND [NumarAI] IS NULL) OR ([NumarAI] = @Original_NumarAI)) AND ((@IsNull_IDPartener = 1 AND [IDPartener] IS NULL) OR ([IDPartener] = @Original_IDPartener)));
SELECT IDContact, Nume, Prenume, IDTipContact, CNP, StareCivila, Functie, Departament, TipAI, SerieAI, NumarAI, IDPartener FROM Contact WHERE (IDContact = @IDContact)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Prenume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Prenume" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@IDTipContact" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDTipContact" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CNP" Precision="13" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="CNP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@StareCivila" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="StareCivila" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Functie" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Functie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Departament" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Departament" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TipAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SerieAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SerieAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@NumarAI" Precision="10" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NumarAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@IDPartener" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="IDPartener" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDContact" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDContact" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nume" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Prenume" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Prenume" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Prenume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Prenume" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDTipContact" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDTipContact" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_IDTipContact" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDTipContact" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CNP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CNP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_CNP" Precision="13" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="CNP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StareCivila" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StareCivila" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_StareCivila" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="StareCivila" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Functie" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Functie" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Functie" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Functie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Departament" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Departament" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Departament" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Departament" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TipAI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TipAI" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TipAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SerieAI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SerieAI" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SerieAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SerieAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NumarAI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumarAI" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_NumarAI" Precision="10" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NumarAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDPartener" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDPartener" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_IDPartener" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="IDPartener" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDContact" ColumnName="IDContact" DataSourceName="ESRP.dbo.Contact" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDContact" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDContact" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDContact" DataSetColumn="IDContact" />
              <Mapping SourceColumn="Nume" DataSetColumn="Nume" />
              <Mapping SourceColumn="Prenume" DataSetColumn="Prenume" />
              <Mapping SourceColumn="IDTipContact" DataSetColumn="IDTipContact" />
              <Mapping SourceColumn="CNP" DataSetColumn="CNP" />
              <Mapping SourceColumn="StareCivila" DataSetColumn="StareCivila" />
              <Mapping SourceColumn="Functie" DataSetColumn="Functie" />
              <Mapping SourceColumn="Departament" DataSetColumn="Departament" />
              <Mapping SourceColumn="TipAI" DataSetColumn="TipAI" />
              <Mapping SourceColumn="SerieAI" DataSetColumn="SerieAI" />
              <Mapping SourceColumn="NumarAI" DataSetColumn="NumarAI" />
              <Mapping SourceColumn="IDPartener" DataSetColumn="IDPartener" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MijloaceTransportTableAdapter" GeneratorDataComponentClassName="MijloaceTransportTableAdapter" Name="MijloaceTransport" UserDataComponentName="MijloaceTransportTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ESRPConnectionString (Settings)" DbObjectName="ESRP.dbo.MijloaceTransport" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [MijloaceTransport] WHERE (([IDMijlocTransport] = @Original_IDMijlocTransport) AND ([Denumire] = @Original_Denumire) AND ([NrInmatriculare] = @Original_NrInmatriculare) AND ([IDPartener] = @Original_IDPartener))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_IDMijlocTransport" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDMijlocTransport" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NrInmatriculare" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NrInmatriculare" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_IDPartener" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="IDPartener" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [MijloaceTransport] ([Denumire], [NrInmatriculare], [IDPartener]) VALUES (@Denumire, @NrInmatriculare, @IDPartener);
SELECT IDMijlocTransport, Denumire, NrInmatriculare, IDPartener FROM MijloaceTransport WHERE (IDMijlocTransport = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NrInmatriculare" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NrInmatriculare" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@IDPartener" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="IDPartener" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDMijlocTransport, Denumire, NrInmatriculare, IDPartener FROM MijloaceTransport</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [MijloaceTransport] SET [Denumire] = @Denumire, [NrInmatriculare] = @NrInmatriculare, [IDPartener] = @IDPartener WHERE (([IDMijlocTransport] = @Original_IDMijlocTransport) AND ([Denumire] = @Original_Denumire) AND ([NrInmatriculare] = @Original_NrInmatriculare) AND ([IDPartener] = @Original_IDPartener));
SELECT IDMijlocTransport, Denumire, NrInmatriculare, IDPartener FROM MijloaceTransport WHERE (IDMijlocTransport = @IDMijlocTransport)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NrInmatriculare" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NrInmatriculare" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@IDPartener" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="IDPartener" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_IDMijlocTransport" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDMijlocTransport" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NrInmatriculare" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NrInmatriculare" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_IDPartener" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="IDPartener" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDMijlocTransport" ColumnName="IDMijlocTransport" DataSourceName="ESRP.dbo.MijloaceTransport" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@IDMijlocTransport" Precision="0" ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="IDMijlocTransport" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDMijlocTransport" DataSetColumn="IDMijlocTransport" />
              <Mapping SourceColumn="Denumire" DataSetColumn="Denumire" />
              <Mapping SourceColumn="NrInmatriculare" DataSetColumn="NrInmatriculare" />
              <Mapping SourceColumn="IDPartener" DataSetColumn="IDPartener" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TiparesteParteneriTableAdapter" GeneratorDataComponentClassName="TiparesteParteneriTableAdapter" Name="TiparesteParteneri" UserDataComponentName="TiparesteParteneriTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ESRPConnectionString (Settings)" DbObjectName="ESRP.dbo.TiparesteParteneri" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.TiparesteParteneri</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@CodUnitate" Precision="5" ProviderType="SmallInt" Scale="0" Size="2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@ParteneriFolositi" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDPartener" DataSetColumn="IDPartener" />
              <Mapping SourceColumn="CUI" DataSetColumn="CUI" />
              <Mapping SourceColumn="Denumire" DataSetColumn="Denumire" />
              <Mapping SourceColumn="DenumireBanca" DataSetColumn="DenumireBanca" />
              <Mapping SourceColumn="ContBancar" DataSetColumn="ContBancar" />
              <Mapping SourceColumn="Cont" DataSetColumn="Cont" />
              <Mapping SourceColumn="CodUnitate" DataSetColumn="CodUnitate" />
              <Mapping SourceColumn="TipPartener" DataSetColumn="TipPartener" />
              <Mapping SourceColumn="Judet" DataSetColumn="Judet" />
              <Mapping SourceColumn="Localitate" DataSetColumn="Localitate" />
              <Mapping SourceColumn="Strada" DataSetColumn="Strada" />
              <Mapping SourceColumn="Nr" DataSetColumn="Nr" />
              <Mapping SourceColumn="AtributFiscal" DataSetColumn="AtributFiscal" />
              <Mapping SourceColumn="JudetRegComert" DataSetColumn="JudetRegComert" />
              <Mapping SourceColumn="NrRegComert" DataSetColumn="NrRegComert" />
              <Mapping SourceColumn="AnRegComert" DataSetColumn="AnRegComert" />
              <Mapping SourceColumn="NumeDelegat" DataSetColumn="NumeDelegat" />
              <Mapping SourceColumn="SerieAI" DataSetColumn="SerieAI" />
              <Mapping SourceColumn="NrAI" DataSetColumn="NrAI" />
              <Mapping SourceColumn="MijlocTransport" DataSetColumn="MijlocTransport" />
              <Mapping SourceColumn="NrMijlocTransport" DataSetColumn="NrMijlocTransport" />
              <Mapping SourceColumn="CodPostal" DataSetColumn="CodPostal" />
              <Mapping SourceColumn="Telefon" DataSetColumn="Telefon" />
              <Mapping SourceColumn="Fax" DataSetColumn="Fax" />
              <Mapping SourceColumn="ContClient" DataSetColumn="ContClient" />
              <Mapping SourceColumn="ConditiiDePlata" DataSetColumn="ConditiiDePlata" />
              <Mapping SourceColumn="Tara" DataSetColumn="Tara" />
              <Mapping SourceColumn="IDContactDelegat" DataSetColumn="IDContactDelegat" />
              <Mapping SourceColumn="IDMijlocTransport" DataSetColumn="IDMijlocTransport" />
              <Mapping SourceColumn="ScadentaFacturiClient" DataSetColumn="ScadentaFacturiClient" />
              <Mapping SourceColumn="ScadentaFacturiFurnizor" DataSetColumn="ScadentaFacturiFurnizor" />
              <Mapping SourceColumn="ScadentaFacturiSfarsitLuna" DataSetColumn="ScadentaFacturiSfarsitLuna" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="ESRPDataSetParteneri" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="ESRPDataSetParteneri" msprop:Generator_UserDSName="ESRPDataSetParteneri">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Parteneri" msprop:Generator_TableClassName="ParteneriDataTable" msprop:Generator_TableVarName="tableParteneri" msprop:Generator_RowChangedName="ParteneriRowChanged" msprop:Generator_TablePropName="Parteneri" msprop:Generator_RowDeletingName="ParteneriRowDeleting" msprop:Generator_RowChangingName="ParteneriRowChanging" msprop:Generator_RowEvHandlerName="ParteneriRowChangeEventHandler" msprop:Generator_RowDeletedName="ParteneriRowDeleted" msprop:Generator_RowClassName="ParteneriRow" msprop:Generator_UserTableName="Parteneri" msprop:Generator_RowEvArgName="ParteneriRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDPartener" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIDPartener" msprop:Generator_ColumnPropNameInRow="IDPartener" msprop:Generator_ColumnPropNameInTable="IDPartenerColumn" msprop:Generator_UserColumnName="IDPartener" type="xs:long" />
              <xs:element name="CUI" msprop:Generator_ColumnVarNameInTable="columnCUI" msprop:Generator_ColumnPropNameInRow="CUI" msprop:Generator_ColumnPropNameInTable="CUIColumn" msprop:Generator_UserColumnName="CUI" type="xs:decimal" />
              <xs:element name="Denumire" msprop:Generator_ColumnVarNameInTable="columnDenumire" msprop:Generator_ColumnPropNameInRow="Denumire" msprop:Generator_ColumnPropNameInTable="DenumireColumn" msprop:Generator_UserColumnName="Denumire">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDBanca" msprop:Generator_ColumnVarNameInTable="columnIDBanca" msprop:Generator_ColumnPropNameInRow="IDBanca" msprop:Generator_ColumnPropNameInTable="IDBancaColumn" msprop:Generator_UserColumnName="IDBanca" type="xs:short" />
              <xs:element name="ContBancar" msprop:Generator_ColumnVarNameInTable="columnContBancar" msprop:Generator_ColumnPropNameInRow="ContBancar" msprop:Generator_ColumnPropNameInTable="ContBancarColumn" msprop:Generator_UserColumnName="ContBancar">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cont" msprop:Generator_ColumnVarNameInTable="columnCont" msprop:Generator_ColumnPropNameInRow="Cont" msprop:Generator_ColumnPropNameInTable="ContColumn" msprop:Generator_UserColumnName="Cont">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CodUnitate" msprop:Generator_ColumnVarNameInTable="columnCodUnitate" msprop:Generator_ColumnPropNameInRow="CodUnitate" msprop:Generator_ColumnPropNameInTable="CodUnitateColumn" msprop:Generator_UserColumnName="CodUnitate" type="xs:short" />
              <xs:element name="TipPartener" msprop:Generator_ColumnVarNameInTable="columnTipPartener" msprop:Generator_ColumnPropNameInRow="TipPartener" msprop:Generator_ColumnPropNameInTable="TipPartenerColumn" msprop:Generator_UserColumnName="TipPartener">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDJudet" msprop:Generator_ColumnVarNameInTable="columnIDJudet" msprop:Generator_ColumnPropNameInRow="IDJudet" msprop:Generator_ColumnPropNameInTable="IDJudetColumn" msprop:Generator_UserColumnName="IDJudet" type="xs:int" />
              <xs:element name="IDLocalitate" msprop:Generator_ColumnVarNameInTable="columnIDLocalitate" msprop:Generator_ColumnPropNameInRow="IDLocalitate" msprop:Generator_ColumnPropNameInTable="IDLocalitateColumn" msprop:Generator_UserColumnName="IDLocalitate" type="xs:int" />
              <xs:element name="Strada" msprop:Generator_ColumnVarNameInTable="columnStrada" msprop:Generator_ColumnPropNameInRow="Strada" msprop:Generator_ColumnPropNameInTable="StradaColumn" msprop:Generator_UserColumnName="Strada" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Nr" msprop:Generator_ColumnVarNameInTable="columnNr" msprop:Generator_ColumnPropNameInRow="Nr" msprop:Generator_ColumnPropNameInTable="NrColumn" msprop:Generator_UserColumnName="Nr" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AtributFiscal" msprop:Generator_ColumnVarNameInTable="columnAtributFiscal" msprop:Generator_ColumnPropNameInRow="AtributFiscal" msprop:Generator_ColumnPropNameInTable="AtributFiscalColumn" msprop:Generator_UserColumnName="AtributFiscal">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JudetRegComert" msprop:Generator_ColumnVarNameInTable="columnJudetRegComert" msprop:Generator_ColumnPropNameInRow="JudetRegComert" msprop:Generator_ColumnPropNameInTable="JudetRegComertColumn" msprop:Generator_UserColumnName="JudetRegComert" type="xs:short" />
              <xs:element name="NrRegComert" msprop:Generator_ColumnVarNameInTable="columnNrRegComert" msprop:Generator_ColumnPropNameInRow="NrRegComert" msprop:Generator_ColumnPropNameInTable="NrRegComertColumn" msprop:Generator_UserColumnName="NrRegComert" type="xs:int" />
              <xs:element name="AnRegComert" msprop:Generator_ColumnVarNameInTable="columnAnRegComert" msprop:Generator_ColumnPropNameInRow="AnRegComert" msprop:Generator_ColumnPropNameInTable="AnRegComertColumn" msprop:Generator_UserColumnName="AnRegComert" type="xs:short" />
              <xs:element name="NumeDelegat" msprop:Generator_ColumnVarNameInTable="columnNumeDelegat" msprop:Generator_ColumnPropNameInRow="NumeDelegat" msprop:Generator_ColumnPropNameInTable="NumeDelegatColumn" msprop:Generator_UserColumnName="NumeDelegat">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SerieAI" msprop:Generator_ColumnVarNameInTable="columnSerieAI" msprop:Generator_ColumnPropNameInRow="SerieAI" msprop:Generator_ColumnPropNameInTable="SerieAIColumn" msprop:Generator_UserColumnName="SerieAI">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NrAI" msprop:Generator_ColumnVarNameInTable="columnNrAI" msprop:Generator_ColumnPropNameInRow="NrAI" msprop:Generator_ColumnPropNameInTable="NrAIColumn" msprop:Generator_UserColumnName="NrAI">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="6" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MijlocTransport" msprop:Generator_ColumnVarNameInTable="columnMijlocTransport" msprop:Generator_ColumnPropNameInRow="MijlocTransport" msprop:Generator_ColumnPropNameInTable="MijlocTransportColumn" msprop:Generator_UserColumnName="MijlocTransport">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NrMijlocTransport" msprop:Generator_ColumnVarNameInTable="columnNrMijlocTransport" msprop:Generator_ColumnPropNameInRow="NrMijlocTransport" msprop:Generator_ColumnPropNameInTable="NrMijlocTransportColumn" msprop:Generator_UserColumnName="NrMijlocTransport">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CodPostal" msprop:Generator_ColumnVarNameInTable="columnCodPostal" msprop:Generator_ColumnPropNameInRow="CodPostal" msprop:Generator_ColumnPropNameInTable="CodPostalColumn" msprop:Generator_UserColumnName="CodPostal" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Telefon" msprop:Generator_ColumnVarNameInTable="columnTelefon" msprop:Generator_ColumnPropNameInRow="Telefon" msprop:Generator_ColumnPropNameInTable="TelefonColumn" msprop:Generator_UserColumnName="Telefon" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Fax" msprop:Generator_ColumnVarNameInTable="columnFax" msprop:Generator_ColumnPropNameInRow="Fax" msprop:Generator_ColumnPropNameInTable="FaxColumn" msprop:Generator_UserColumnName="Fax" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ContClient" msprop:Generator_ColumnVarNameInTable="columnContClient" msprop:Generator_ColumnPropNameInRow="ContClient" msprop:Generator_ColumnPropNameInTable="ContClientColumn" msprop:Generator_UserColumnName="ContClient" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ConditiiDePlata" msprop:Generator_ColumnVarNameInTable="columnConditiiDePlata" msprop:Generator_ColumnPropNameInRow="ConditiiDePlata" msprop:Generator_ColumnPropNameInTable="ConditiiDePlataColumn" msprop:Generator_UserColumnName="ConditiiDePlata" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDTara" msprop:Generator_ColumnVarNameInTable="columnIDTara" msprop:Generator_ColumnPropNameInRow="IDTara" msprop:Generator_ColumnPropNameInTable="IDTaraColumn" msprop:Generator_UserColumnName="IDTara" type="xs:int" minOccurs="0" />
              <xs:element name="IDContactDelegat" msprop:Generator_ColumnVarNameInTable="columnIDContactDelegat" msprop:Generator_ColumnPropNameInRow="IDContactDelegat" msprop:Generator_ColumnPropNameInTable="IDContactDelegatColumn" msprop:Generator_UserColumnName="IDContactDelegat" type="xs:int" minOccurs="0" />
              <xs:element name="IDMijlocTransport" msprop:Generator_ColumnVarNameInTable="columnIDMijlocTransport" msprop:Generator_ColumnPropNameInRow="IDMijlocTransport" msprop:Generator_ColumnPropNameInTable="IDMijlocTransportColumn" msprop:Generator_UserColumnName="IDMijlocTransport" type="xs:short" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Banci" msprop:Generator_TableClassName="BanciDataTable" msprop:Generator_TableVarName="tableBanci" msprop:Generator_RowChangedName="BanciRowChanged" msprop:Generator_TablePropName="Banci" msprop:Generator_RowDeletingName="BanciRowDeleting" msprop:Generator_RowChangingName="BanciRowChanging" msprop:Generator_RowEvHandlerName="BanciRowChangeEventHandler" msprop:Generator_RowDeletedName="BanciRowDeleted" msprop:Generator_RowClassName="BanciRow" msprop:Generator_UserTableName="Banci" msprop:Generator_RowEvArgName="BanciRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdBanca" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIdBanca" msprop:Generator_ColumnPropNameInRow="IdBanca" msprop:Generator_ColumnPropNameInTable="IdBancaColumn" msprop:Generator_UserColumnName="IdBanca" type="xs:short" />
              <xs:element name="Denumire" msprop:Generator_ColumnVarNameInTable="columnDenumire" msprop:Generator_ColumnPropNameInRow="Denumire" msprop:Generator_ColumnPropNameInTable="DenumireColumn" msprop:Generator_UserColumnName="Denumire">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BIC" msprop:Generator_ColumnVarNameInTable="columnBIC" msprop:Generator_ColumnPropNameInRow="BIC" msprop:Generator_ColumnPropNameInTable="BICColumn" msprop:Generator_UserColumnName="BIC">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Conturi" msprop:Generator_TableClassName="ConturiDataTable" msprop:Generator_TableVarName="tableConturi" msprop:Generator_RowChangedName="ConturiRowChanged" msprop:Generator_TablePropName="Conturi" msprop:Generator_RowDeletingName="ConturiRowDeleting" msprop:Generator_RowChangingName="ConturiRowChanging" msprop:Generator_RowEvHandlerName="ConturiRowChangeEventHandler" msprop:Generator_RowDeletedName="ConturiRowDeleted" msprop:Generator_RowClassName="ConturiRow" msprop:Generator_UserTableName="Conturi" msprop:Generator_RowEvArgName="ConturiRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Cont" msprop:Generator_ColumnVarNameInTable="columnCont" msprop:Generator_ColumnPropNameInRow="Cont" msprop:Generator_ColumnPropNameInTable="ContColumn" msprop:Generator_UserColumnName="Cont">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CodUnitate" msprop:Generator_ColumnVarNameInTable="columnCodUnitate" msprop:Generator_ColumnPropNameInRow="CodUnitate" msprop:Generator_ColumnPropNameInTable="CodUnitateColumn" msprop:Generator_UserColumnName="CodUnitate" type="xs:short" />
              <xs:element name="Denumire" msprop:Generator_ColumnVarNameInTable="columnDenumire" msprop:Generator_ColumnPropNameInRow="Denumire" msprop:Generator_ColumnPropNameInTable="DenumireColumn" msprop:Generator_UserColumnName="Denumire">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Tip" msprop:Generator_ColumnVarNameInTable="columnTip" msprop:Generator_ColumnPropNameInRow="Tip" msprop:Generator_ColumnPropNameInTable="TipColumn" msprop:Generator_UserColumnName="Tip">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Terminal" msprop:Generator_ColumnVarNameInTable="columnTerminal" msprop:Generator_ColumnPropNameInRow="Terminal" msprop:Generator_ColumnPropNameInTable="TerminalColumn" msprop:Generator_UserColumnName="Terminal" type="xs:boolean" />
              <xs:element name="ContParinte" msprop:Generator_ColumnVarNameInTable="columnContParinte" msprop:Generator_ColumnPropNameInRow="ContParinte" msprop:Generator_ColumnPropNameInTable="ContParinteColumn" msprop:Generator_UserColumnName="ContParinte">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EsteAnalitic" msprop:Generator_ColumnVarNameInTable="columnEsteAnalitic" msprop:Generator_ColumnPropNameInRow="EsteAnalitic" msprop:Generator_ColumnPropNameInTable="EsteAnaliticColumn" msprop:Generator_UserColumnName="EsteAnalitic" type="xs:boolean" />
              <xs:element name="DebitInitial" msprop:Generator_ColumnVarNameInTable="columnDebitInitial" msprop:Generator_ColumnPropNameInRow="DebitInitial" msprop:Generator_ColumnPropNameInTable="DebitInitialColumn" msprop:Generator_UserColumnName="DebitInitial" type="xs:decimal" />
              <xs:element name="CreditInitial" msprop:Generator_ColumnVarNameInTable="columnCreditInitial" msprop:Generator_ColumnPropNameInRow="CreditInitial" msprop:Generator_ColumnPropNameInTable="CreditInitialColumn" msprop:Generator_UserColumnName="CreditInitial" type="xs:decimal" />
              <xs:element name="DebitPrecedent" msprop:Generator_ColumnVarNameInTable="columnDebitPrecedent" msprop:Generator_ColumnPropNameInRow="DebitPrecedent" msprop:Generator_ColumnPropNameInTable="DebitPrecedentColumn" msprop:Generator_UserColumnName="DebitPrecedent" type="xs:decimal" />
              <xs:element name="CreditPrecedent" msprop:Generator_ColumnVarNameInTable="columnCreditPrecedent" msprop:Generator_ColumnPropNameInRow="CreditPrecedent" msprop:Generator_ColumnPropNameInTable="CreditPrecedentColumn" msprop:Generator_UserColumnName="CreditPrecedent" type="xs:decimal" />
              <xs:element name="Categorie" msprop:Generator_ColumnVarNameInTable="columnCategorie" msprop:Generator_ColumnPropNameInRow="Categorie" msprop:Generator_ColumnPropNameInTable="CategorieColumn" msprop:Generator_UserColumnName="Categorie" type="xs:unsignedByte" />
              <xs:element name="RulajDebit" msprop:Generator_ColumnVarNameInTable="columnRulajDebit" msprop:Generator_ColumnPropNameInRow="RulajDebit" msprop:Generator_ColumnPropNameInTable="RulajDebitColumn" msprop:Generator_UserColumnName="RulajDebit" type="xs:decimal" />
              <xs:element name="RulajCredit" msprop:Generator_ColumnVarNameInTable="columnRulajCredit" msprop:Generator_ColumnPropNameInRow="RulajCredit" msprop:Generator_ColumnPropNameInTable="RulajCreditColumn" msprop:Generator_UserColumnName="RulajCredit" type="xs:decimal" />
              <xs:element name="Sold" msprop:Generator_ColumnVarNameInTable="columnSold" msprop:Generator_ColumnPropNameInRow="Sold" msprop:Generator_ColumnPropNameInTable="SoldColumn" msprop:Generator_UserColumnName="Sold" type="xs:decimal" />
              <xs:element name="SortValue" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnSortValue" msprop:Generator_ColumnPropNameInRow="SortValue" msprop:Generator_ColumnPropNameInTable="SortValueColumn" msprop:Generator_UserColumnName="SortValue" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Judete" msprop:Generator_TableClassName="JudeteDataTable" msprop:Generator_TableVarName="tableJudete" msprop:Generator_RowChangedName="JudeteRowChanged" msprop:Generator_TablePropName="Judete" msprop:Generator_RowDeletingName="JudeteRowDeleting" msprop:Generator_RowChangingName="JudeteRowChanging" msprop:Generator_RowEvHandlerName="JudeteRowChangeEventHandler" msprop:Generator_RowDeletedName="JudeteRowDeleted" msprop:Generator_RowClassName="JudeteRow" msprop:Generator_UserTableName="Judete" msprop:Generator_RowEvArgName="JudeteRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDJudet" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIDJudet" msprop:Generator_ColumnPropNameInRow="IDJudet" msprop:Generator_ColumnPropNameInTable="IDJudetColumn" msprop:Generator_UserColumnName="IDJudet" type="xs:int" />
              <xs:element name="Nume" msprop:Generator_ColumnVarNameInTable="columnNume" msprop:Generator_ColumnPropNameInRow="Nume" msprop:Generator_ColumnPropNameInTable="NumeColumn" msprop:Generator_UserColumnName="Nume" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Sigla" msprop:Generator_ColumnVarNameInTable="columnSigla" msprop:Generator_ColumnPropNameInRow="Sigla" msprop:Generator_ColumnPropNameInTable="SiglaColumn" msprop:Generator_UserColumnName="Sigla" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PrefixTelefonic" msprop:Generator_ColumnVarNameInTable="columnPrefixTelefonic" msprop:Generator_ColumnPropNameInRow="PrefixTelefonic" msprop:Generator_ColumnPropNameInTable="PrefixTelefonicColumn" msprop:Generator_UserColumnName="PrefixTelefonic" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ResedintaJudet" msprop:Generator_ColumnVarNameInTable="columnResedintaJudet" msprop:Generator_ColumnPropNameInRow="ResedintaJudet" msprop:Generator_ColumnPropNameInTable="ResedintaJudetColumn" msprop:Generator_UserColumnName="ResedintaJudet" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDTara" msprop:Generator_ColumnVarNameInTable="columnIDTara" msprop:Generator_ColumnPropNameInRow="IDTara" msprop:Generator_ColumnPropNameInTable="IDTaraColumn" msprop:Generator_UserColumnName="IDTara" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Localitati" msprop:Generator_TableClassName="LocalitatiDataTable" msprop:Generator_TableVarName="tableLocalitati" msprop:Generator_RowChangedName="LocalitatiRowChanged" msprop:Generator_TablePropName="Localitati" msprop:Generator_RowDeletingName="LocalitatiRowDeleting" msprop:Generator_RowChangingName="LocalitatiRowChanging" msprop:Generator_RowEvHandlerName="LocalitatiRowChangeEventHandler" msprop:Generator_RowDeletedName="LocalitatiRowDeleted" msprop:Generator_RowClassName="LocalitatiRow" msprop:Generator_UserTableName="Localitati" msprop:Generator_RowEvArgName="LocalitatiRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDLocalitate" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIDLocalitate" msprop:Generator_ColumnPropNameInRow="IDLocalitate" msprop:Generator_ColumnPropNameInTable="IDLocalitateColumn" msprop:Generator_UserColumnName="IDLocalitate" type="xs:int" />
              <xs:element name="Nume" msprop:Generator_ColumnVarNameInTable="columnNume" msprop:Generator_ColumnPropNameInRow="Nume" msprop:Generator_ColumnPropNameInTable="NumeColumn" msprop:Generator_UserColumnName="Nume" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CodPostal" msprop:Generator_ColumnVarNameInTable="columnCodPostal" msprop:Generator_ColumnPropNameInRow="CodPostal" msprop:Generator_ColumnPropNameInTable="CodPostalColumn" msprop:Generator_UserColumnName="CodPostal" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="6" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDJudet" msprop:Generator_ColumnVarNameInTable="columnIDJudet" msprop:Generator_ColumnPropNameInRow="IDJudet" msprop:Generator_ColumnPropNameInTable="IDJudetColumn" msprop:Generator_UserColumnName="IDJudet" type="xs:int" minOccurs="0" />
              <xs:element name="PrefixTelefonic" msprop:Generator_ColumnVarNameInTable="columnPrefixTelefonic" msprop:Generator_ColumnPropNameInRow="PrefixTelefonic" msprop:Generator_ColumnPropNameInTable="PrefixTelefonicColumn" msprop:Generator_UserColumnName="PrefixTelefonic" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Tari" msprop:Generator_TableClassName="TariDataTable" msprop:Generator_TableVarName="tableTari" msprop:Generator_TablePropName="Tari" msprop:Generator_RowDeletingName="TariRowDeleting" msprop:Generator_RowChangingName="TariRowChanging" msprop:Generator_RowEvHandlerName="TariRowChangeEventHandler" msprop:Generator_RowDeletedName="TariRowDeleted" msprop:Generator_UserTableName="Tari" msprop:Generator_RowChangedName="TariRowChanged" msprop:Generator_RowEvArgName="TariRowChangeEvent" msprop:Generator_RowClassName="TariRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDTara" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIDTara" msprop:Generator_ColumnPropNameInRow="IDTara" msprop:Generator_ColumnPropNameInTable="IDTaraColumn" msprop:Generator_UserColumnName="IDTara" type="xs:int" />
              <xs:element name="NUME" msprop:Generator_ColumnVarNameInTable="columnNUME" msprop:Generator_ColumnPropNameInRow="NUME" msprop:Generator_ColumnPropNameInTable="NUMEColumn" msprop:Generator_UserColumnName="NUME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SIGLA" msprop:Generator_ColumnVarNameInTable="columnSIGLA" msprop:Generator_ColumnPropNameInRow="SIGLA" msprop:Generator_ColumnPropNameInTable="SIGLAColumn" msprop:Generator_UserColumnName="SIGLA" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="preftel" msprop:Generator_ColumnVarNameInTable="columnpreftel" msprop:Generator_ColumnPropNameInRow="preftel" msprop:Generator_ColumnPropNameInTable="preftelColumn" msprop:Generator_UserColumnName="preftel" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Contact" msprop:Generator_TableClassName="ContactDataTable" msprop:Generator_TableVarName="tableContact" msprop:Generator_RowChangedName="ContactRowChanged" msprop:Generator_TablePropName="Contact" msprop:Generator_RowDeletingName="ContactRowDeleting" msprop:Generator_RowChangingName="ContactRowChanging" msprop:Generator_RowEvHandlerName="ContactRowChangeEventHandler" msprop:Generator_RowDeletedName="ContactRowDeleted" msprop:Generator_RowClassName="ContactRow" msprop:Generator_UserTableName="Contact" msprop:Generator_RowEvArgName="ContactRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDContact" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIDContact" msprop:Generator_ColumnPropNameInRow="IDContact" msprop:Generator_ColumnPropNameInTable="IDContactColumn" msprop:Generator_UserColumnName="IDContact" type="xs:int" />
              <xs:element name="Nume" msprop:Generator_ColumnVarNameInTable="columnNume" msprop:Generator_ColumnPropNameInRow="Nume" msprop:Generator_ColumnPropNameInTable="NumeColumn" msprop:Generator_UserColumnName="Nume" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Prenume" msprop:Generator_ColumnVarNameInTable="columnPrenume" msprop:Generator_ColumnPropNameInRow="Prenume" msprop:Generator_ColumnPropNameInTable="PrenumeColumn" msprop:Generator_UserColumnName="Prenume" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDTipContact" msprop:Generator_ColumnVarNameInTable="columnIDTipContact" msprop:Generator_ColumnPropNameInRow="IDTipContact" msprop:Generator_ColumnPropNameInTable="IDTipContactColumn" msprop:Generator_UserColumnName="IDTipContact" type="xs:short" minOccurs="0" />
              <xs:element name="CNP" msprop:Generator_ColumnVarNameInTable="columnCNP" msprop:Generator_ColumnPropNameInRow="CNP" msprop:Generator_ColumnPropNameInTable="CNPColumn" msprop:Generator_UserColumnName="CNP" type="xs:decimal" minOccurs="0" />
              <xs:element name="StareCivila" msprop:Generator_ColumnVarNameInTable="columnStareCivila" msprop:Generator_ColumnPropNameInRow="StareCivila" msprop:Generator_ColumnPropNameInTable="StareCivilaColumn" msprop:Generator_UserColumnName="StareCivila" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Functie" msprop:Generator_ColumnVarNameInTable="columnFunctie" msprop:Generator_ColumnPropNameInRow="Functie" msprop:Generator_ColumnPropNameInTable="FunctieColumn" msprop:Generator_UserColumnName="Functie" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Departament" msprop:Generator_ColumnVarNameInTable="columnDepartament" msprop:Generator_ColumnPropNameInRow="Departament" msprop:Generator_ColumnPropNameInTable="DepartamentColumn" msprop:Generator_UserColumnName="Departament" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TipAI" msprop:Generator_ColumnVarNameInTable="columnTipAI" msprop:Generator_ColumnPropNameInRow="TipAI" msprop:Generator_ColumnPropNameInTable="TipAIColumn" msprop:Generator_UserColumnName="TipAI" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SerieAI" msprop:Generator_ColumnVarNameInTable="columnSerieAI" msprop:Generator_ColumnPropNameInRow="SerieAI" msprop:Generator_ColumnPropNameInTable="SerieAIColumn" msprop:Generator_UserColumnName="SerieAI" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NumarAI" msprop:Generator_ColumnVarNameInTable="columnNumarAI" msprop:Generator_ColumnPropNameInRow="NumarAI" msprop:Generator_ColumnPropNameInTable="NumarAIColumn" msprop:Generator_UserColumnName="NumarAI" type="xs:decimal" minOccurs="0" />
              <xs:element name="IDPartener" msprop:Generator_ColumnVarNameInTable="columnIDPartener" msprop:Generator_ColumnPropNameInRow="IDPartener" msprop:Generator_ColumnPropNameInTable="IDPartenerColumn" msprop:Generator_UserColumnName="IDPartener" type="xs:long" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="MijloaceTransport" msprop:Generator_TableClassName="MijloaceTransportDataTable" msprop:Generator_TableVarName="tableMijloaceTransport" msprop:Generator_RowChangedName="MijloaceTransportRowChanged" msprop:Generator_TablePropName="MijloaceTransport" msprop:Generator_RowDeletingName="MijloaceTransportRowDeleting" msprop:Generator_RowChangingName="MijloaceTransportRowChanging" msprop:Generator_RowEvHandlerName="MijloaceTransportRowChangeEventHandler" msprop:Generator_RowDeletedName="MijloaceTransportRowDeleted" msprop:Generator_RowClassName="MijloaceTransportRow" msprop:Generator_UserTableName="MijloaceTransport" msprop:Generator_RowEvArgName="MijloaceTransportRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDMijlocTransport" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIDMijlocTransport" msprop:Generator_ColumnPropNameInRow="IDMijlocTransport" msprop:Generator_ColumnPropNameInTable="IDMijlocTransportColumn" msprop:Generator_UserColumnName="IDMijlocTransport" type="xs:short" />
              <xs:element name="Denumire" msprop:Generator_ColumnVarNameInTable="columnDenumire" msprop:Generator_ColumnPropNameInRow="Denumire" msprop:Generator_ColumnPropNameInTable="DenumireColumn" msprop:Generator_UserColumnName="Denumire">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NrInmatriculare" msprop:Generator_ColumnVarNameInTable="columnNrInmatriculare" msprop:Generator_ColumnPropNameInRow="NrInmatriculare" msprop:Generator_ColumnPropNameInTable="NrInmatriculareColumn" msprop:Generator_UserColumnName="NrInmatriculare">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDPartener" msprop:Generator_ColumnVarNameInTable="columnIDPartener" msprop:Generator_ColumnPropNameInRow="IDPartener" msprop:Generator_ColumnPropNameInTable="IDPartenerColumn" msprop:Generator_UserColumnName="IDPartener" type="xs:long" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TiparesteParteneri" msprop:Generator_TableClassName="TiparesteParteneriDataTable" msprop:Generator_TableVarName="tableTiparesteParteneri" msprop:Generator_TablePropName="TiparesteParteneri" msprop:Generator_RowDeletingName="TiparesteParteneriRowDeleting" msprop:Generator_RowChangingName="TiparesteParteneriRowChanging" msprop:Generator_RowEvHandlerName="TiparesteParteneriRowChangeEventHandler" msprop:Generator_RowDeletedName="TiparesteParteneriRowDeleted" msprop:Generator_UserTableName="TiparesteParteneri" msprop:Generator_RowChangedName="TiparesteParteneriRowChanged" msprop:Generator_RowEvArgName="TiparesteParteneriRowChangeEvent" msprop:Generator_RowClassName="TiparesteParteneriRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDPartener" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_ColumnVarNameInTable="columnIDPartener" msprop:Generator_ColumnPropNameInRow="IDPartener" msprop:Generator_ColumnPropNameInTable="IDPartenerColumn" msprop:Generator_UserColumnName="IDPartener" type="xs:long" />
              <xs:element name="CUI" msprop:Generator_ColumnVarNameInTable="columnCUI" msprop:Generator_ColumnPropNameInRow="CUI" msprop:Generator_ColumnPropNameInTable="CUIColumn" msprop:Generator_UserColumnName="CUI" type="xs:decimal" />
              <xs:element name="Denumire" msprop:Generator_ColumnVarNameInTable="columnDenumire" msprop:Generator_ColumnPropNameInRow="Denumire" msprop:Generator_ColumnPropNameInTable="DenumireColumn" msprop:Generator_UserColumnName="Denumire">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DenumireBanca" msprop:Generator_ColumnVarNameInTable="columnDenumireBanca" msprop:Generator_ColumnPropNameInRow="DenumireBanca" msprop:Generator_ColumnPropNameInTable="DenumireBancaColumn" msprop:Generator_UserColumnName="DenumireBanca" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ContBancar" msprop:Generator_ColumnVarNameInTable="columnContBancar" msprop:Generator_ColumnPropNameInRow="ContBancar" msprop:Generator_ColumnPropNameInTable="ContBancarColumn" msprop:Generator_UserColumnName="ContBancar">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cont" msprop:Generator_ColumnVarNameInTable="columnCont" msprop:Generator_ColumnPropNameInRow="Cont" msprop:Generator_ColumnPropNameInTable="ContColumn" msprop:Generator_UserColumnName="Cont">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CodUnitate" msprop:Generator_ColumnVarNameInTable="columnCodUnitate" msprop:Generator_ColumnPropNameInRow="CodUnitate" msprop:Generator_ColumnPropNameInTable="CodUnitateColumn" msprop:Generator_UserColumnName="CodUnitate" type="xs:short" />
              <xs:element name="TipPartener" msprop:Generator_ColumnVarNameInTable="columnTipPartener" msprop:Generator_ColumnPropNameInRow="TipPartener" msprop:Generator_ColumnPropNameInTable="TipPartenerColumn" msprop:Generator_UserColumnName="TipPartener">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Judet" msprop:Generator_ColumnVarNameInTable="columnJudet" msprop:Generator_ColumnPropNameInRow="Judet" msprop:Generator_ColumnPropNameInTable="JudetColumn" msprop:Generator_UserColumnName="Judet" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Localitate" msprop:Generator_ColumnVarNameInTable="columnLocalitate" msprop:Generator_ColumnPropNameInRow="Localitate" msprop:Generator_ColumnPropNameInTable="LocalitateColumn" msprop:Generator_UserColumnName="Localitate" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Strada" msprop:Generator_ColumnVarNameInTable="columnStrada" msprop:Generator_ColumnPropNameInRow="Strada" msprop:Generator_ColumnPropNameInTable="StradaColumn" msprop:Generator_UserColumnName="Strada" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Nr" msprop:Generator_ColumnVarNameInTable="columnNr" msprop:Generator_ColumnPropNameInRow="Nr" msprop:Generator_ColumnPropNameInTable="NrColumn" msprop:Generator_UserColumnName="Nr" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AtributFiscal" msprop:Generator_ColumnVarNameInTable="columnAtributFiscal" msprop:Generator_ColumnPropNameInRow="AtributFiscal" msprop:Generator_ColumnPropNameInTable="AtributFiscalColumn" msprop:Generator_UserColumnName="AtributFiscal">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JudetRegComert" msprop:Generator_ColumnVarNameInTable="columnJudetRegComert" msprop:Generator_ColumnPropNameInRow="JudetRegComert" msprop:Generator_ColumnPropNameInTable="JudetRegComertColumn" msprop:Generator_UserColumnName="JudetRegComert" type="xs:short" />
              <xs:element name="NrRegComert" msprop:Generator_ColumnVarNameInTable="columnNrRegComert" msprop:Generator_ColumnPropNameInRow="NrRegComert" msprop:Generator_ColumnPropNameInTable="NrRegComertColumn" msprop:Generator_UserColumnName="NrRegComert" type="xs:int" />
              <xs:element name="AnRegComert" msprop:Generator_ColumnVarNameInTable="columnAnRegComert" msprop:Generator_ColumnPropNameInRow="AnRegComert" msprop:Generator_ColumnPropNameInTable="AnRegComertColumn" msprop:Generator_UserColumnName="AnRegComert" type="xs:short" />
              <xs:element name="NumeDelegat" msprop:Generator_ColumnVarNameInTable="columnNumeDelegat" msprop:Generator_ColumnPropNameInRow="NumeDelegat" msprop:Generator_ColumnPropNameInTable="NumeDelegatColumn" msprop:Generator_UserColumnName="NumeDelegat">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SerieAI" msprop:Generator_ColumnVarNameInTable="columnSerieAI" msprop:Generator_ColumnPropNameInRow="SerieAI" msprop:Generator_ColumnPropNameInTable="SerieAIColumn" msprop:Generator_UserColumnName="SerieAI">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NrAI" msprop:Generator_ColumnVarNameInTable="columnNrAI" msprop:Generator_ColumnPropNameInRow="NrAI" msprop:Generator_ColumnPropNameInTable="NrAIColumn" msprop:Generator_UserColumnName="NrAI">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="6" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MijlocTransport" msprop:Generator_ColumnVarNameInTable="columnMijlocTransport" msprop:Generator_ColumnPropNameInRow="MijlocTransport" msprop:Generator_ColumnPropNameInTable="MijlocTransportColumn" msprop:Generator_UserColumnName="MijlocTransport">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NrMijlocTransport" msprop:Generator_ColumnVarNameInTable="columnNrMijlocTransport" msprop:Generator_ColumnPropNameInRow="NrMijlocTransport" msprop:Generator_ColumnPropNameInTable="NrMijlocTransportColumn" msprop:Generator_UserColumnName="NrMijlocTransport">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CodPostal" msprop:Generator_ColumnVarNameInTable="columnCodPostal" msprop:Generator_ColumnPropNameInRow="CodPostal" msprop:Generator_ColumnPropNameInTable="CodPostalColumn" msprop:Generator_UserColumnName="CodPostal" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Telefon" msprop:Generator_ColumnVarNameInTable="columnTelefon" msprop:Generator_ColumnPropNameInRow="Telefon" msprop:Generator_ColumnPropNameInTable="TelefonColumn" msprop:Generator_UserColumnName="Telefon" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Fax" msprop:Generator_ColumnVarNameInTable="columnFax" msprop:Generator_ColumnPropNameInRow="Fax" msprop:Generator_ColumnPropNameInTable="FaxColumn" msprop:Generator_UserColumnName="Fax" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ContClient" msprop:Generator_ColumnVarNameInTable="columnContClient" msprop:Generator_ColumnPropNameInRow="ContClient" msprop:Generator_ColumnPropNameInTable="ContClientColumn" msprop:Generator_UserColumnName="ContClient" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ConditiiDePlata" msprop:Generator_ColumnVarNameInTable="columnConditiiDePlata" msprop:Generator_ColumnPropNameInRow="ConditiiDePlata" msprop:Generator_ColumnPropNameInTable="ConditiiDePlataColumn" msprop:Generator_UserColumnName="ConditiiDePlata" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Tara" msprop:Generator_ColumnVarNameInTable="columnTara" msprop:Generator_ColumnPropNameInRow="Tara" msprop:Generator_ColumnPropNameInTable="TaraColumn" msprop:Generator_UserColumnName="Tara" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDContactDelegat" msprop:Generator_ColumnVarNameInTable="columnIDContactDelegat" msprop:Generator_ColumnPropNameInRow="IDContactDelegat" msprop:Generator_ColumnPropNameInTable="IDContactDelegatColumn" msprop:Generator_UserColumnName="IDContactDelegat" type="xs:int" minOccurs="0" />
              <xs:element name="IDMijlocTransport" msprop:Generator_ColumnVarNameInTable="columnIDMijlocTransport" msprop:Generator_ColumnPropNameInRow="IDMijlocTransport" msprop:Generator_ColumnPropNameInTable="IDMijlocTransportColumn" msprop:Generator_UserColumnName="IDMijlocTransport" type="xs:short" minOccurs="0" />
              <xs:element name="ScadentaFacturiClient" msprop:Generator_ColumnVarNameInTable="columnScadentaFacturiClient" msprop:Generator_ColumnPropNameInRow="ScadentaFacturiClient" msprop:Generator_ColumnPropNameInTable="ScadentaFacturiClientColumn" msprop:Generator_UserColumnName="ScadentaFacturiClient" type="xs:int" minOccurs="0" />
              <xs:element name="ScadentaFacturiFurnizor" msprop:Generator_ColumnVarNameInTable="columnScadentaFacturiFurnizor" msprop:Generator_ColumnPropNameInRow="ScadentaFacturiFurnizor" msprop:Generator_ColumnPropNameInTable="ScadentaFacturiFurnizorColumn" msprop:Generator_UserColumnName="ScadentaFacturiFurnizor" type="xs:int" minOccurs="0" />
              <xs:element name="ScadentaFacturiSfarsitLuna" msprop:Generator_ColumnVarNameInTable="columnScadentaFacturiSfarsitLuna" msprop:Generator_ColumnPropNameInRow="ScadentaFacturiSfarsitLuna" msprop:Generator_ColumnPropNameInTable="ScadentaFacturiSfarsitLunaColumn" msprop:Generator_UserColumnName="ScadentaFacturiSfarsitLuna" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Parteneri" />
      <xs:field xpath="mstns:IDPartener" />
    </xs:unique>
    <xs:unique name="Banci_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Banci" />
      <xs:field xpath="mstns:IdBanca" />
    </xs:unique>
    <xs:unique name="Conturi_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Conturi" />
      <xs:field xpath="mstns:Cont" />
      <xs:field xpath="mstns:CodUnitate" />
    </xs:unique>
    <xs:unique name="Judete_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Judete" />
      <xs:field xpath="mstns:IDJudet" />
    </xs:unique>
    <xs:unique name="Localitati_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Localitati" />
      <xs:field xpath="mstns:IDLocalitate" />
    </xs:unique>
    <xs:unique name="Tari_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Tari" />
      <xs:field xpath="mstns:IDTara" />
    </xs:unique>
    <xs:unique name="Contact_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Contact" />
      <xs:field xpath="mstns:IDContact" />
    </xs:unique>
    <xs:unique name="MijloaceTransport_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:MijloaceTransport" />
      <xs:field xpath="mstns:IDMijlocTransport" />
    </xs:unique>
    <xs:unique name="TiparesteParteneri_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TiparesteParteneri" />
      <xs:field xpath="mstns:IDPartener" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Conturi_Conturi" msdata:parent="Conturi" msdata:child="Conturi" msdata:parentkey="Cont CodUnitate" msdata:childkey="ContParinte CodUnitate" msprop:Generator_UserChildTable="Conturi" msprop:Generator_ChildPropName="GetConturiRows" msprop:Generator_UserRelationName="FK_Conturi_Conturi" msprop:Generator_RelationVarName="relationFK_Conturi_Conturi" msprop:Generator_UserParentTable="Conturi" msprop:Generator_ParentPropName="ConturiRowParent" />
      <msdata:Relationship name="FK_LOCALITATI_JUDETE" msdata:parent="Judete" msdata:child="Localitati" msdata:parentkey="IDJudet" msdata:childkey="IDJudet" msprop:Generator_UserChildTable="Localitati" msprop:Generator_ChildPropName="GetLocalitatiRows" msprop:Generator_UserRelationName="FK_LOCALITATI_JUDETE" msprop:Generator_ParentPropName="JudeteRow" msprop:Generator_RelationVarName="relationFK_LOCALITATI_JUDETE" msprop:Generator_UserParentTable="Judete" />
      <msdata:Relationship name="FK_Judete_Tari" msdata:parent="Tari" msdata:child="Judete" msdata:parentkey="IDTara" msdata:childkey="IDTara" msprop:Generator_UserChildTable="Judete" msprop:Generator_ChildPropName="GetJudeteRows" msprop:Generator_UserRelationName="FK_Judete_Tari" msprop:Generator_RelationVarName="relationFK_Judete_Tari" msprop:Generator_UserParentTable="Tari" msprop:Generator_ParentPropName="TariRow" />
      <msdata:Relationship name="FK_Parteneri_Contact" msdata:parent="Contact" msdata:child="Parteneri" msdata:parentkey="IDContact" msdata:childkey="IDContactDelegat" msprop:Generator_UserChildTable="Parteneri" msprop:Generator_ChildPropName="GetParteneriRows" msprop:Generator_UserRelationName="FK_Parteneri_Contact" msprop:Generator_ParentPropName="ContactRow" msprop:Generator_RelationVarName="relationFK_Parteneri_Contact" msprop:Generator_UserParentTable="Contact" />
      <msdata:Relationship name="FK_Parteneri_MijloaceTransport" msdata:parent="MijloaceTransport" msdata:child="Parteneri" msdata:parentkey="IDMijlocTransport" msdata:childkey="IDMijlocTransport" msprop:Generator_UserChildTable="Parteneri" msprop:Generator_ChildPropName="GetParteneriRows" msprop:Generator_UserRelationName="FK_Parteneri_MijloaceTransport" msprop:Generator_ParentPropName="MijloaceTransportRow" msprop:Generator_RelationVarName="relationFK_Parteneri_MijloaceTransport" msprop:Generator_UserParentTable="MijloaceTransport" />
      <msdata:Relationship name="FK_Contact_Parteneri" msdata:parent="Parteneri" msdata:child="Contact" msdata:parentkey="IDPartener" msdata:childkey="IDPartener" msprop:Generator_UserChildTable="Contact" msprop:Generator_ChildPropName="GetContactRows" msprop:Generator_UserRelationName="FK_Contact_Parteneri" msprop:Generator_RelationVarName="relationFK_Contact_Parteneri" msprop:Generator_UserParentTable="Parteneri" msprop:Generator_ParentPropName="ParteneriRow" />
      <msdata:Relationship name="FK_MijloaceTransport_Parteneri" msdata:parent="Parteneri" msdata:child="MijloaceTransport" msdata:parentkey="IDPartener" msdata:childkey="IDPartener" msprop:Generator_UserChildTable="MijloaceTransport" msprop:Generator_ChildPropName="GetMijloaceTransportRows" msprop:Generator_UserRelationName="FK_MijloaceTransport_Parteneri" msprop:Generator_RelationVarName="relationFK_MijloaceTransport_Parteneri" msprop:Generator_UserParentTable="Parteneri" msprop:Generator_ParentPropName="ParteneriRow" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>